import sqlite3

db_name = "information_manager.db"

try:
    conn = sqlite3.connect(db_name)
    cursor = conn.cursor()
    
    # 检查表结构
    cursor.execute("SELECT name FROM sqlite_master WHERE type='table'")
    tables = cursor.fetchall()
    
    print("数据库中的表:")
    for table in tables:
        print(f"  {table[0]}")
        
        # 显示表结构
        cursor.execute(f"PRAGMA table_info({table[0]})")
        columns = cursor.fetchall()
        print("    结构:")
        for column in columns:
            print(f"      {column[1]} ({column[2]})")
    
    conn.close()
except Exception as e:
    print(f"检查数据库时出错: {str(e)}")